set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go

--CREATEd:02/08/2010
--Author: nnamthach@gmail.com
Create procedure [dbo].[procUser_get_ByEmail](
@Email as nchar(50)
)
AS
BEGIN 
SELECT
	ID,
	Email,
	Password,
	FullName,
	Address,
	Mobile,
	City,
	Country,
	Sex,
	Score
	
FROM  dbo.[User]
WHERE 	(
		@Email = Email 
)
END

